<?php // $Id: reportsgraph.php,v 1.8.2.3 2008/11/29 14:30:58 skodak Exp $

	require_once('../../../config.php');
	require_once($CFG->dirroot.'/lib/statslib.php');
	require_once($CFG->dirroot.'/lib/graphlib.php');

	$report	 = required_param('report', PARAM_INT);
	$time	   = required_param('time', PARAM_INT);
	$numcourses = required_param('numcourses', PARAM_INT);

	require_login();

	require_capability('report/courseoverview:view', get_context_instance(CONTEXT_SYSTEM));

	stats_check_uptodate();

	$param = stats_get_parameters($time,$report,SITEID,STATS_MODE_RANKED);

	if (!empty($param->sql)) {
		$sql = $param->sql;
	} else {
		$sql = "SELECT courseid,".$param->fields." FROM ".$CFG->prefix.'stats_'.$param->table
			." WHERE timeend >= $param->timeafter AND stattype = 'activity' AND roleid = 0"
			." GROUP BY courseid "
			.$param->extras
			." ORDER BY ".$param->orderby;
	}

	$courses = get_records_sql($sql, 0, $numcourses);

	if (empty($courses)) {
		print_error('statsnodata', "", $CFG->wwwroot.'/'.$CFG->admin.'/report/courseoverview/index.php');
	}


	$graph = new graph(750,400);

	$graph->parameter['legend'] = 'outside-right';
	$graph->parameter['legend_size'] = 10;
	$graph->parameter['x_axis_angle'] = 90;
	$graph->parameter['title'] = false; // moodle will do a nicer job.
	$graph->y_tick_labels = null;
	$graph->offset_relation = null;
	if ($report != STATS_REPORT_ACTIVE_COURSES) {
		$graph->parameter['y_decimal_left'] = 2;
	}

	foreach ($courses as $c) {
		$graph->x_data[] = get_field('course','shortname','id',$c->courseid);
		$graph->y_data['bar1'][] = $c->{$param->graphline};
	}
	$graph->y_order = array('bar1');
	$graph->y_format['bar1'] = array('colour' => 'blue','bar' => 'fill','legend' => $param->{$param->graphline});

	$graph->draw_stack();

?>
